drop table if exists  jms_tmp.tmp_waybill_sign_taking_time_quantum_dt;
create external table  jms_tmp.tmp_waybill_sign_taking_time_quantum_dt (
 pick_network_code               string   comment '揽收网点code'
,pick_network_name               string   comment '揽收网点name'
,dispatch_network_code           string   comment '派件网点'
,dispatch_network_name           string   comment '派件网点'
,latest_warehousing_time_quantum string   comment '揽收时间段'
,sign_days                       string   comment '签收天'
,waybill_count                   bigint   comment '运单数量'
,free_is_flag                    bigint   comment '快手时效能否匹配到路由'
,cainiao_route_days              bigint   comment '菜鸟路由天数'
,reback_write                    bigint   comment '时效回写类型：1：路由，0：实际'
,cainiao_is_flag                 bigint   comment '菜鸟时效能否匹配到路由'
)
comment '签收网点汇总表带揽收时间段'
partitioned by (
    dt         string comment '更新日期 (yyyy-mm-dd)')
stored as parquet
location '/dw/hive/jms_tmp.db/external/tmp_waybill_sign_taking_time_quantum_dt'
tblproperties (
    'discover.partitions' = 'false',
    'parquet.column.index.access' = 'true'
    );